/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 50625
Source Host           : 127.0.0.1:3306
Source Database       : epoch_game

Target Server Type    : MYSQL
Target Server Version : 50625
File Encoding         : 65001

Date: 2018-08-10 17:28:59
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `s_version`
-- ----------------------------
DROP TABLE IF EXISTS `s_version`;
CREATE TABLE `s_version` (
`version`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '当前数据库的版本号' ,
`time`  bigint(20) NULL DEFAULT NULL COMMENT '更新版本的时间戳' ,
PRIMARY KEY (`version`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of s_version
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `s_whitelist`
-- ----------------------------
DROP TABLE IF EXISTS `s_whitelist`;
CREATE TABLE `s_whitelist` (
`id`  int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID' ,
`type`  int(11) NULL DEFAULT NULL COMMENT '0-地址白名单，1-账号白名单' ,
`value`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '白名单' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=121

;

-- ----------------------------
-- Records of s_whitelist
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_activity_counter`
-- ----------------------------
DROP TABLE IF EXISTS `t_activity_counter`;
CREATE TABLE `t_activity_counter` (
`id`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主键：act_reward_param' ,
`activityId`  int(11) NULL DEFAULT NULL COMMENT '活动id' ,
`rewardId`  int(11) NULL DEFAULT NULL COMMENT '奖励id' ,
`count`  bigint(20) NULL DEFAULT NULL COMMENT '计数' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of t_activity_counter
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_boss`
-- ----------------------------
DROP TABLE IF EXISTS `t_boss`;
CREATE TABLE `t_boss` (
`bossId`  int(11) NOT NULL DEFAULT 0 COMMENT 'bossId' ,
`nextRefreshTime`  bigint(20) NULL DEFAULT NULL COMMENT 'boss下次刷新时间' ,
`firstKillers`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '首杀队伍' ,
`beforeKillers`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '上次击杀队伍' ,
PRIMARY KEY (`bossId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='Boss数据'

;

-- ----------------------------
-- Records of t_boss
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_filtertext`
-- ----------------------------
DROP TABLE IF EXISTS `t_filtertext`;
CREATE TABLE `t_filtertext` (
`text`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
PRIMARY KEY (`text`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='屏蔽词库'

;

-- ----------------------------
-- Records of t_filtertext
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_friend`
-- ----------------------------
DROP TABLE IF EXISTS `t_friend`;
CREATE TABLE `t_friend` (
`id`  bigint(11) NOT NULL COMMENT '玩家id' ,
`friends`  varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '好友id列表' ,
`requests`  varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '好友请求' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of t_friend
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_golduse`
-- ----------------------------
DROP TABLE IF EXISTS `t_golduse`;
CREATE TABLE `t_golduse` (
`id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键' ,
`playerId`  bigint(20) NULL DEFAULT NULL COMMENT '玩家id' ,
`userId`  bigint(20) NULL DEFAULT NULL COMMENT '用户id' ,
`useNum`  int(11) NULL DEFAULT NULL COMMENT '扣除数量' ,
`remainNum`  int(11) NULL DEFAULT NULL COMMENT '当前剩余数' ,
`totalUse`  int(11) NULL DEFAULT NULL COMMENT '总消耗数' ,
`reason`  int(11) NULL DEFAULT NULL COMMENT '操作源' ,
`useTime`  bigint(20) NULL DEFAULT NULL COMMENT '扣除时间' ,
PRIMARY KEY (`id`),
INDEX `playerId` (`playerId`) USING BTREE ,
INDEX `time` (`useTime`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=1

;

-- ----------------------------
-- Records of t_golduse
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_item_change_history`
-- ----------------------------
DROP TABLE IF EXISTS `t_item_change_history`;
CREATE TABLE `t_item_change_history` (
`id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id' ,
`playerId`  bigint(20) NULL DEFAULT NULL COMMENT '角色id' ,
`changeNum`  int(11) NULL DEFAULT NULL COMMENT '改变值' ,
`modelId`  int(11) NULL DEFAULT NULL COMMENT '物品id' ,
`timestamp`  bigint(20) NULL DEFAULT NULL COMMENT '消耗时间戳' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=7308019

;

-- ----------------------------
-- Records of t_item_change_history
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_mail`
-- ----------------------------
DROP TABLE IF EXISTS `t_mail`;
CREATE TABLE `t_mail` (
`mail_id`  bigint(20) NOT NULL DEFAULT 0 COMMENT '邮件id' ,
`receiver_id`  bigint(20) NULL DEFAULT NULL COMMENT '接收者玩家id' ,
`receiver_name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '接收者玩家名称' ,
`send_time`  int(20) NULL DEFAULT NULL COMMENT '发送时间' ,
`endTime`  bigint(20) NULL DEFAULT NULL COMMENT '失效时间' ,
`titile`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮件标题' ,
`senderName`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发送方信息（系统、活动等）' ,
`content`  varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文本' ,
`items`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '附件物品' ,
`state`  tinyint(2) NULL DEFAULT NULL COMMENT '状态：1已读取 0为读取' ,
`eventKey`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '后台生成的key值' ,
`createRoleTimeBegin`  bigint(20) NULL DEFAULT 0 COMMENT '创建角色起始时间' ,
`createRoleTimeEnd`  bigint(20) NULL DEFAULT 0 COMMENT '创建角色截止时间' ,
`levelMax`  int(11) NULL DEFAULT NULL COMMENT '最大等级限制' ,
`levelMin`  int(11) NULL DEFAULT 0 COMMENT '最小等级限制' ,
`timeStamp`  bigint(20) NULL DEFAULT NULL COMMENT '时间戳' ,
`gotAttach`  bit(1) NULL DEFAULT b'0' COMMENT '是否已领取附件' ,
PRIMARY KEY (`mail_id`),
INDEX `mail_id` (`mail_id`) USING BTREE ,
INDEX `receiver_id` (`receiver_id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of t_mail
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_mail_schedule`
-- ----------------------------
DROP TABLE IF EXISTS `t_mail_schedule`;
CREATE TABLE `t_mail_schedule` (
`mailId`  bigint(20) NOT NULL AUTO_INCREMENT COMMENT '邮件id' ,
`mailJson`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '邮件详情' ,
PRIMARY KEY (`mailId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=655393826

;

-- ----------------------------
-- Records of t_mail_schedule
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_mail_sync`
-- ----------------------------
DROP TABLE IF EXISTS `t_mail_sync`;
CREATE TABLE `t_mail_sync` (
`playerId`  bigint(20) NOT NULL DEFAULT 0 COMMENT '玩家id' ,
`syncGlobalTimeStamp`  bigint(20) NULL DEFAULT NULL COMMENT '最后同步全局邮件的时间戳' ,
`mailServerId`  int(11) NULL DEFAULT NULL COMMENT '服务器id，若发现mailServerId变更，重置readGlobalTimeStamp' ,
PRIMARY KEY (`playerId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='角色同步群发邮件记录'

;

-- ----------------------------
-- Records of t_mail_sync
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_money`
-- ----------------------------
DROP TABLE IF EXISTS `t_money`;
CREATE TABLE `t_money` (
`playerId`  bigint(20) NOT NULL DEFAULT 0 COMMENT '玩家Id' ,
`playerName`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '玩家名称' ,
`userId`  bigint(20) NULL DEFAULT NULL COMMENT '用户id' ,
`userName`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名' ,
`playerType`  tinyint(4) NULL DEFAULT NULL COMMENT '玩家类型，0-正常玩家，1-内部玩家' ,
`money`  bigint(20) NULL DEFAULT NULL COMMENT '当前金币数' ,
`gold`  int(11) NULL DEFAULT NULL COMMENT '当前的钻石数' ,
`testGold`  int(11) NULL DEFAULT NULL COMMENT '当前的测试钻石数' ,
`moneyTotal`  bigint(20) NULL DEFAULT NULL COMMENT '获得金币累计' ,
`moneyUse`  bigint(20) NULL DEFAULT NULL COMMENT '使用金币累计' ,
`goldTotal`  bigint(20) NULL DEFAULT NULL COMMENT '获得钻石总数' ,
`goldRechargeTotal`  bigint(20) NULL DEFAULT NULL COMMENT '充值获得的钻石总数' ,
`goldUse`  bigint(20) NULL DEFAULT NULL COMMENT '扣除钻石总数' ,
`testGoldTotal`  bigint(20) NULL DEFAULT NULL COMMENT '获得测试钻石总数' ,
`testGoldUse`  bigint(20) NULL DEFAULT NULL COMMENT '扣除测试钻石总数' ,
PRIMARY KEY (`playerId`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of t_money
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_pay`
-- ----------------------------
DROP TABLE IF EXISTS `t_pay`;
CREATE TABLE `t_pay` (
`orderId`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '订单id' ,
`serverId`  int(11) NOT NULL COMMENT '服务器id' ,
`userId`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'userId' ,
`roleId`  bigint(20) UNSIGNED NOT NULL COMMENT '角色id' ,
`propId`  int(11) NOT NULL COMMENT '商品id' ,
`actualPrice`  int(11) NOT NULL COMMENT '价格' ,
`checkCode`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '校验码' ,
`status`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态字符串' ,
`time`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'CURRENT_TIMESTAMP' COMMENT '时间' ,
`channelId`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '渠道id' ,
`goodPrice`  int(11) NULL DEFAULT NULL COMMENT '商品价格' ,
`giveNum`  int(11) NULL DEFAULT NULL COMMENT '赠送数量' ,
`playerName`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`playerLevel`  int(11) NULL DEFAULT NULL COMMENT '充值时玩家等级' ,
`totalRmb`  int(11) NULL DEFAULT NULL COMMENT '充值RMB总额' ,
`totalRecharge`  bigint(20) NULL DEFAULT NULL COMMENT '总充值' ,
`currentNum`  int(11) NULL DEFAULT NULL COMMENT '当前符石数量' ,
`lastUpdateTime`  bigint(20) NULL DEFAULT NULL COMMENT '最后更新时间' ,
PRIMARY KEY (`orderId`),
UNIQUE INDEX `orderId` (`orderId`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of t_pay
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_player`
-- ----------------------------
DROP TABLE IF EXISTS `t_player`;
CREATE TABLE `t_player` (
`id`  bigint(20) NOT NULL DEFAULT 0 COMMENT '角色id' ,
`name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称' ,
`userId`  bigint(20) NULL DEFAULT NULL COMMENT '用户id' ,
`userName`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`createServer`  int(11) NULL DEFAULT NULL COMMENT '创角服务器id' ,
`createAgent`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建平台' ,
`roleModelId`  int(11) NULL DEFAULT 0 COMMENT '角色模板id' ,
`level`  int(11) NULL DEFAULT NULL COMMENT '等级' ,
`exp`  bigint(20) NULL DEFAULT NULL COMMENT '经验' ,
`job`  tinyint(6) NULL DEFAULT NULL COMMENT '职业' ,
`mapGroup`  int(11) NULL DEFAULT NULL ,
`mapSn`  int(11) NULL DEFAULT NULL COMMENT '所在地图编号' ,
`preMapSn`  int(11) NULL DEFAULT 0 COMMENT '上一普通地图编号' ,
`sex`  tinyint(6) NULL DEFAULT NULL ,
`mainData`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '玩家的主要数据' ,
`loginTime`  bigint(20) NULL DEFAULT NULL COMMENT '登录时间' ,
`silverCoin`  bigint(20) NULL DEFAULT NULL COMMENT '银币数量' ,
`goldenCoin`  bigint(20) NULL DEFAULT NULL COMMENT '金币数量' ,
`bindGold`  bigint(20) NULL DEFAULT 0 COMMENT '绑定符石数量' ,
`testGold`  int(11) NULL DEFAULT NULL COMMENT '内币数量' ,
`mainMissionId`  int(11) NULL DEFAULT NULL COMMENT '主线任务id' ,
`loginIp`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录ip' ,
`valid`  tinyint(4) NULL DEFAULT 0 COMMENT '0-有效，1-封号，2-删除' ,
`validTime`  bigint(20) NULL DEFAULT 0 COMMENT '解封时间' ,
`type`  tinyint(4) NULL DEFAULT NULL COMMENT '0-正式玩家，1-游客玩家' ,
`updateTime`  bigint(20) NULL DEFAULT NULL COMMENT '最后更新时间' ,
`items`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '装备外观' ,
`equipQuality`  int(11) NULL DEFAULT 0 COMMENT '1-全装备紫色, 2-全装备紫色且同一套装, 3-全装备橙色且同一套装' ,
`bagItems`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '背包物品数据' ,
`storageItems`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '仓库物品数据' ,
`equips`  varchar(2500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '穿着数据' ,
`totalRecharge`  bigint(20) NULL DEFAULT 0 COMMENT '充值总额' ,
`totalExpend`  bigint(20) NULL DEFAULT 0 COMMENT '钻石总消耗' ,
`createTime`  bigint(20) NULL DEFAULT 0 COMMENT '创建时间' ,
`channel`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '渠道' ,
`fashionId`  int(11) NULL DEFAULT 0 COMMENT '时装ID' ,
`artifactId`  int(11) NULL DEFAULT 0 COMMENT '神器ID' ,
`innerSignals`  int(11) NULL DEFAULT NULL COMMENT '1-内部号 2-gs号 3-内部号和gs号' ,
PRIMARY KEY (`id`),
INDEX `ik_name` (`name`) USING BTREE ,
INDEX `ik_userid` (`userId`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='角色表'

;

-- ----------------------------
-- Records of t_player
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_player_mirror`
-- ----------------------------
DROP TABLE IF EXISTS `t_player_mirror`;
CREATE TABLE `t_player_mirror` (
`id`  bigint(20) NOT NULL DEFAULT 0 COMMENT 'id' ,
`name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '角色名' ,
`roleModelId`  int(11) NULL DEFAULT 0 COMMENT '角色模型' ,
`level`  int(11) NULL DEFAULT NULL COMMENT '等级' ,
`fightPower`  int(11) NULL DEFAULT NULL COMMENT '战斗力' ,
`title`  int(11) NULL DEFAULT NULL COMMENT '称号' ,
`guild`  bigint(20) NULL DEFAULT NULL COMMENT '公会ID' ,
`guildName`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '帮会名称' ,
`surface`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`fashionId`  int(11) NULL DEFAULT 0 COMMENT '玩家正在穿戴的时装ID' ,
`artifactId`  int(11) NULL DEFAULT 0 COMMENT '玩家正在穿戴的神器ID' ,
`equipQuality`  int(11) NULL DEFAULT 0 COMMENT '1-全装备紫色,2-全装备紫色且同一套装, 3-全装备橙色且同一套装' ,
`fightAttribute`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '战斗属性' ,
`skills`  varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '已经获得的所有技能' ,
`fightingHeroes`  varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出战英雄' ,
`valid`  tinyint(6) NULL DEFAULT NULL COMMENT '状态：0有效，1-封号,2-已删号' ,
`hp`  int(11) NULL DEFAULT NULL COMMENT '当前血量' ,
`items`  varchar(3000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色装备' ,
`posGems`  varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部位镶嵌' ,
`mount`  int(11) NULL DEFAULT 0 COMMENT '幻化坐骑模型' ,
PRIMARY KEY (`id`),
INDEX `ik_name` (`name`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of t_player_mirror
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_server_data`
-- ----------------------------
DROP TABLE IF EXISTS `t_server_data`;
CREATE TABLE `t_server_data` (
`serverId`  int(10) NULL DEFAULT NULL ,
`ultimateKey`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
`intVal`  int(11) NULL DEFAULT 0 COMMENT '整形值' ,
`jsonStr`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
PRIMARY KEY (`ultimateKey`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci

;

-- ----------------------------
-- Records of t_server_data
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_todo`
-- ----------------------------
DROP TABLE IF EXISTS `t_todo`;
CREATE TABLE `t_todo` (
`id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id' ,
`playerId`  bigint(20) NULL DEFAULT NULL COMMENT '玩家id' ,
`type`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '待办类型' ,
`data`  varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '代办数据' ,
`createTime`  bigint(20) NULL DEFAULT NULL COMMENT '创建时间' ,
PRIMARY KEY (`id`),
INDEX `IX_playerId` (`playerId`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=36181691

;

-- ----------------------------
-- Records of t_todo
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_uid`
-- ----------------------------
DROP TABLE IF EXISTS `t_uid`;
CREATE TABLE `t_uid` (
`type`  int(11) NOT NULL COMMENT 'uid类型' ,
`sequenceMax`  bigint(20) NULL DEFAULT NULL ,
PRIMARY KEY (`type`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='唯一id'

;

-- ----------------------------
-- Records of t_uid
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`userId`  bigint(20) NOT NULL COMMENT '账号id' ,
`userName`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号名称' ,
`password`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码' ,
`state`  int(11) NULL DEFAULT NULL COMMENT '账号状态' ,
`agent`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '平台标识' ,
`server`  int(11) NULL DEFAULT NULL COMMENT '服务器id' ,
`createTime`  bigint(20) NULL DEFAULT NULL COMMENT '创建时间' ,
`loginTime`  bigint(20) NULL DEFAULT NULL COMMENT '上次登录时间' ,
`type`  tinyint(4) NULL DEFAULT NULL COMMENT '账号类型：0-正常账号，1-游客账号' ,
`bindTryer`  bigint(20) NULL DEFAULT NULL COMMENT '绑定的游客账号id' ,
`accountCode`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号激活码' ,
`gold`  bigint(20) NOT NULL DEFAULT 0 COMMENT '符石数量' ,
`hasRechargeVersion`  int(11) NULL DEFAULT NULL COMMENT '首充记录版本' ,
`hasRechargeProds`  varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '首充记录' ,
`loginVersion`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登陆客户端版本号' ,
`tel`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '电话' ,
`payBack`  bit(1) NULL DEFAULT b'0' COMMENT '付费测试充值金额是否已返还' ,
`payBackPlayer`  bigint(20) NULL DEFAULT NULL COMMENT '已返还给的角色id' ,
PRIMARY KEY (`userId`),
INDEX `ix` (`userName`, `agent`, `server`, `password`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
COMMENT='用户表'

;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Auto increment value for `s_whitelist`
-- ----------------------------
ALTER TABLE `s_whitelist` AUTO_INCREMENT=121;

-- ----------------------------
-- Auto increment value for `t_golduse`
-- ----------------------------
ALTER TABLE `t_golduse` AUTO_INCREMENT=1;

-- ----------------------------
-- Auto increment value for `t_item_change_history`
-- ----------------------------
ALTER TABLE `t_item_change_history` AUTO_INCREMENT=7308019;

-- ----------------------------
-- Auto increment value for `t_mail_schedule`
-- ----------------------------
ALTER TABLE `t_mail_schedule` AUTO_INCREMENT=655393826;

-- ----------------------------
-- Auto increment value for `t_todo`
-- ----------------------------
ALTER TABLE `t_todo` AUTO_INCREMENT=36181691;
